<?php 
global $DB;
$DB->query("select title,url,speaker,date_format(posted_date, '%M %e, %Y, %W %l:%i%p') as date_formatted_cool from media where datediff(curdate(),posted_date) <= 180 order by posted_date desc");

while($row = $DB->fetch_row())
{
	if(trim($row['url']) != '' && trim($row['title']) != '') {
		print '<strong>' . $row['title'] . '</strong>&nbsp;&nbsp;<a style="font-weight:bold;" href="' . $row['url'] . '" target="_blank"><img src="/Public/images/Phone_57.gif" border="0"></a><br>';
		if(trim($row['date_formatted_cool']) != '') {
			print '<span style="font-style:italic;">' . $row['date_formatted_cool'] . '</span><br>';
		}
		if(trim($row['speaker']) != '') {
			print '<span>' . $row['speaker'] . '</span><br>';
		}
	}
	print '<br>';
}
?>

